Introduction
The Independent Evaluation Group (IEG) is a vital unit within the
World Bank Group with a mission to improve development results and
evaluate the Bank Group’s self-evaluation and development risk
management systems. The IEG World Bank Project Performance Ratings
Dataset is a collection of ratings from all World Bank project
assessments performed independently by IEG. Spanning over 30 years, The
IEG World Bank Project Performance Ratings Dataset contains a collection
of performance ratings from all the World Bank project assessments
conducted by IEG. The dataset has data from over 11,260 project
assessments covering more than 9,400 completed projects and is the
longest-running project performance data collection of its kind. The
ratings are based on a common objectives-based project evaluation
methodology and use standardized scales to assign performance
ratings.
Problem Statement
Despite numerous government programs aimed at solving various issues
such as health, food assistance, education, and housing, it remains a
challenge to measure the success and growth of these projects. The IEG
World Bank Project Performance Ratings Dataset aims to provide an
in-depth analysis of the success rate and project performance of the
different programs in which the World Bank has invested. However, the
data collected by IEG is vast and complex, making it difficult for
stakeholders to understand and use it to make informed decisions. It’s
essential to have a reliable system in place to assess the success rate
of these programs and to provide a performance rating to the World
Bank’s investment in these programs. The goal of this data visualization
project is to create a user-friendly and interactive platform that
presents the IEG World Bank Project Performance Ratings Dataset in a way
that is accessible, informative, and visually appealing. The platform
should allow stakeholders to easily analyze the performance of specific
projects, compare performance across projects and programs, and identify
trends and patterns in the data. The aim of this data visualization
project is to showcase the performance ratings of World Bank projects
and to provide insights into the effectiveness of these programs. By
presenting the data in a visually engaging and straightforward manner,
this project aims to help stakeholders make informed decisions and
improve the development results of the World Bank Group across various
regions of the world.
Section 1
In this section we will be delving into a regional analysis of World
Bank financed projects. The World Bank operates in various
administrative regions across the world, including Africa (AFR), East
Asia Pacific (EAP), Europe and Central Asia (ECA), Latin America and
Caribbean (LCR), Middle East and North Africa (MNA), and South Asia
(SAR). This analysis will provide a comprehensive overview of the World
Bank’s activities and their impact in each of these regions.
Question 1
Which region in the world has the maximum number of countries where
the World Bank is financing different kinds of projects?

Output 1
It’s evident that the World Bank is providing financial support to
projects across the six regions of the world. We observed that the
African Region (AFR) consists of the highest number of countries (51)
that were offered loans by the World Bank for various projects. From our
analysis, we also noticed that the South Asian Region (SAR) consists of
the least number of countries (9) that were offered loans by the World
Bank for various projects.
Question 2
What are the top 5 countries in the world that have received the
highest grant from the World Bank?
## `geom_line()`: Each group consists of only one observation.
## ℹ Do you need to adjust the group aesthetic?
## `geom_line()`: Each group consists of only one observation.
## ℹ Do you need to adjust the group aesthetic?

Output 2
From the line plot, we observed that the top 5 countries that have
received the highest grant from the World Bank are in the following
order: China > India > Mexico > Brazil > Pakistan. The
amount that these countries received is the sum of all the grants that
they received from the World Bank for various projects over the
years.
Question 3
What are the top three sector boards with the most number of
projects across all six regions?
## `summarise()` has grouped output by 'Region'. You can override using the
## `.groups` argument.
## `summarise()` has grouped output by 'Sector.Board'. You can override using the
## `.groups` argument.
## `summarise()` has grouped output by 'Region'. You can override using the
## `.groups` argument.

Output 3
From the stacked bar plot, we can observe that among the 28 sector
boards, Agriculture & Rural Development tops the list with the
highest number of projects across all six regions. Energy & Mining
and Transport follow closely behind as the second and third sector
boards with the most number of projects across all six regions.
Question 4
What is the percentage distribution of the projects according to the
sector board in South Asia Region?

Output 4
In the South Asian region, a majority of projects are focused on
environmental sustainability (59%) and poverty reduction (28%).
Conversely, relatively few projects are dedicated to capital markets
practices and financial systems, with only 1% to 2% of projects falling
into these sector board categories.
Section 2
In this section, we’ll delve into the lending constraints for
projects financed by the World Bank. We’ll focus on three key
constraints: the agreement type between the borrower and the World Bank,
and the total project lending cost, which is the total loan amount
provided by the World Bank for a specific project and lending instrument
type which are of three types Development Policy Financing(DPF),
Investment Project Financing (IPF) and Program for Results Financing
(PforR).
Question 1:
What are the top 2 agreement types signed between the borrower and
the World Bank for all the projects approved after 2000?
## `summarise()` has grouped output by 'Agreement Type'. You can override using
## the `.groups` argument.

Output 1
According to the bubble chart analysis, the most frequently signed
agreement types between borrowers and the World Bank for projects
approved post-2000 are the International Development Association (IDA)
and the International Bank for Reconstruction and Development (IBRD).
The Recipient Executed Trust Fund (RETF) also features as a notable
agreement type, albeit to a lesser extent.
Question 2:
For all the projects that have lending project cost more than 1
billion dollars, what was the Lending Instrument Type that was most
commonly used?

Output 2
From the pie chart, we observed that the most commonly used Lending
Instrument Type is Investment Project Financing (IPF) - 75.53% followed
by Development Policy Financing (DPF) - 23.93%.
Section 3
In this section, we’ll delve into the analysis of the project
success rate financed that were financed by the World Bank.
Output 1
It can be observed that only South Asian Region (SAR) and Middle
East and North Africa (MNA) regions have less projects with highly and
moderately satisfactory rating. In comparison to that, African Region
(AFR), East Asian Pacific (EAP) and Europe and Central Asia (ECA)
regions have more number of projects with satisfactory rating.
Particularly, it can be seen that AFR region has the highest number of
projects with satisfactory rating. Also, African Region (AFR) contains
high number of moderately satisfactory ratings.
Output 2
From the violin plot, we observed that the median lending project
cost for all projects in India having Unsatisfactory project outcomes is
315.75 million dollars and Highly Satisfactory project outcome is 328
million dollars.
Summary and Conclusion
In conclusion, the World Bank is actively providing financial
support to projects in the six regions of the world, with the African
Region being the most benefited with 51 countries receiving loans for
various projects. The top five countries receiving the highest grant
from the World Bank are China, India, Mexico, Brazil, and Pakistan. The
sector board with the highest number of projects across all six regions
is Agriculture & Rural Development, followed by Energy & Mining
and Transport. In the South Asian Region, most of the projects are
focused on environmental sustainability and poverty reduction, with
fewer projects dedicated to capital markets practices and financial
systems. The visualization project provides a clear picture of the World
Bank’s focus and efforts in supporting the growth and development of
different countries and regions.
Also, we observed that the World Bank primarily signs
agreements with borrowers for projects approved post-2000 through the
International Development Association (IDA) and the International Bank
for Reconstruction and Development (IBRD). Although the Recipient
Executed Trust Fund (RETF) is also used, it is used to a lesser extent.
The most commonly used Lending Instrument Type is Investment Project
Financing (IPF), accounting for 75.53% of all lending instruments,
followed by Development Policy Financing (DPF) at 23.93%. These findings
provide insight into the World Bank’s lending practices and highlight
the importance of IDA and IBRD as the primary agreement types and IPF as
the primary lending instrument type used for projects approved after
2000.
In addition to this we observed that the South Asian Region
(SAR) and the Middle East and North Africa (MNA) have fewer projects
with high and moderate satisfaction ratings compared to other regions.
On the other hand, the African Region (AFR), the East Asian Pacific
(EAP), and the Europe and Central Asia (ECA) regions have a higher
number of projects with satisfactory ratings, with the AFR region having
the highest number of satisfactory ratings. The violin plot also shows
that for India, the median lending project cost for projects with
unsatisfactory outcomes is 315.75 million dollars, while for projects
with highly satisfactory outcomes, it is 328 million dollars. These
findings provide valuable information about the performance of World
Bank projects across different regions and their impact on the countries
they serve.